UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Dk6nR0DWsDeEIe9U77nP46+QLlsPacNvlqkePzVg6XM=' 
WHERE 
  key_id = 'aac420ceee54b03e3097d845b5c5abf42352c406ed114e9a26ec29b1cb40ebe6' 
  AND (
    token = 'Dk6nR0DWsDeEIe9U77nP46+QLlsPacNvlqkePzVg6XM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045