UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NiKVoTnjD21AM64rz66g/SM9/7FqV2G0YarXiItpCkw=' 
WHERE 
  key_id = 'af8e63108a490d6f057233a26486f01b1302136a1ddb90b59b6b1b664bb46804' 
  AND (
    token = 'NiKVoTnjD21AM64rz66g/SM9/7FqV2G0YarXiItpCkw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042