UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+2WUy7UPF6rb4ungFE6H1HhF/25czTSzFxygn+cQIw0=' 
WHERE 
  key_id = '1bd0e7faf7f5be40ef6f3e7fa945b53dc22a9364eb907ccf957213bf1c16240b' 
  AND (
    token = '+2WUy7UPF6rb4ungFE6H1HhF/25czTSzFxygn+cQIw0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023