UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Xpf8MI04L6KjaGk+3PmRGz3RGF+CdXz6RPNFyWKGX2w=' 
WHERE 
  key_id = 'bdc9d1426ca1a1bba2a408d50d736cb99955116d1f336a9b7a8cac38420d676a' 
  AND (
    token = 'Xpf8MI04L6KjaGk+3PmRGz3RGF+CdXz6RPNFyWKGX2w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040