UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TZisLRSQeSwgi4PFXnSTHBeGmIvYAlSB0nARR+PwRtQ=' 
WHERE 
  key_id = '992da90093c8d34314a120e70c5de0276e57eb17ec440b27f7d5c798d6f3b308' 
  AND (
    token = 'TZisLRSQeSwgi4PFXnSTHBeGmIvYAlSB0nARR+PwRtQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043