UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bJMe/tyi3M+53JfFEQwJ+JqcyeZG9Fj94eSkCH8w4ts=' 
WHERE 
  key_id = 'bbb34e0b63236a2d041bf14139ffc80a4cbc8ca7ac7d02f84a14a1a34e56e0ae' 
  AND (
    token = 'bJMe/tyi3M+53JfFEQwJ+JqcyeZG9Fj94eSkCH8w4ts=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040