UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'c++HWomdyLaw2/rwFJ07/nDVa2XI6KP09aL+4xnql3s=' 
WHERE 
  key_id = 'fb42155b9364b310ad8c87bed1dd7ec78b1ce4a07a2b68bf3732ce7bf512bfd2' 
  AND (
    token = 'c++HWomdyLaw2/rwFJ07/nDVa2XI6KP09aL+4xnql3s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022