UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2TG4O5pLOkrRZqKkUDbD2QTF5rX9U/Bxhpc8Th4CWOw=' 
WHERE 
  key_id = 'b8ca4d0e9a14c53d20ce76b5e858defb19eded56411b3e624245a0c2f0e7927d' 
  AND (
    token = '2TG4O5pLOkrRZqKkUDbD2QTF5rX9U/Bxhpc8Th4CWOw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048