UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '88Semx+5zg7SGO6hEOwxtzIiUjqdXrRNx4GSnaKwA14=' 
WHERE 
  key_id = 'e8651ce8b65a34bfc6616f824de3e35d8f85d4b850e16ff605f435518b1a56a8' 
  AND (
    token = '88Semx+5zg7SGO6hEOwxtzIiUjqdXrRNx4GSnaKwA14=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030