UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8ilhAX4XlM3WcmuCPDcWJgPJ0kVDcJHSVHyK/KVQPIo=' 
WHERE 
  key_id = '06ebba60b0dce64c1fcdb9c00e25dbdd283638459c806d6fe780eaf4f2e12274' 
  AND (
    token = '8ilhAX4XlM3WcmuCPDcWJgPJ0kVDcJHSVHyK/KVQPIo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031