UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '92Jh4aq8VkFsLnxzGSj1TkCcoM0dgHv7W4dJDTHdxKk=' 
WHERE 
  key_id = '7ce59c8d9ab4527b5f50943cd0227fe2bdceda421b2b92ac3efcb10b365ac7bc' 
  AND (
    token = '92Jh4aq8VkFsLnxzGSj1TkCcoM0dgHv7W4dJDTHdxKk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032