UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UcQoHzcRx/Fc1+irh9PFWoX5qrN8erMXY0O1JoAzksc=' 
WHERE 
  key_id = '38d1c9a4dbe3c9f6ce5b40f3e055bcdd70a74d07110c469d1f3c108d5a092b29' 
  AND (
    token = 'UcQoHzcRx/Fc1+irh9PFWoX5qrN8erMXY0O1JoAzksc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052