UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WOqIBlhM273y0JnTlvv15fwcNVl1t7sozp1VYy+cepo=' 
WHERE 
  key_id = '12a4eabc383d58f6d8d99e3e439e3479b9299e88a9e370d8760e366cf4cf3152' 
  AND (
    token = 'WOqIBlhM273y0JnTlvv15fwcNVl1t7sozp1VYy+cepo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026