UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/DFEIpwM4a8UyHXs4eHXJe4HGc6j7ZqsD+QBcGIfusE=' 
WHERE 
  key_id = 'de34ceb71cb9d0c8e9f04a6302be05b01848ff02579f48328991ec3534659e56' 
  AND (
    token = '/DFEIpwM4a8UyHXs4eHXJe4HGc6j7ZqsD+QBcGIfusE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033