UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mQ7NlwbWQ4CJNT6A66l8nyja0v0kINW+MW24f/SFRRg=' 
WHERE 
  key_id = 'd99b34324fc857d7ccc5ff66ea4b55748e90596326a0d2a9a38e72d99d7e849f' 
  AND (
    token = 'mQ7NlwbWQ4CJNT6A66l8nyja0v0kINW+MW24f/SFRRg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020