UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xUcxYr54DeI4oQVGZiRonRkK8/brvZ44sav1n/+tpt8='
WHERE
key_id = '27131814e976fd415e5898c2a4f72d07f519bf4ba24f9d9f2a90a4a9c6897066'
AND (
token = 'xUcxYr54DeI4oQVGZiRonRkK8/brvZ44sav1n/+tpt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)