UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vUW/Hv4Kwzk09+04MkJNSC8GKvw8dA+dE9wD+3CpCw0='
WHERE
key_id = 'cf553f9882bb0899faf08f50c16459ff5169e8c2b6eb1410576badcdc62b1ac5'
AND (
token = 'vUW/Hv4Kwzk09+04MkJNSC8GKvw8dA+dE9wD+3CpCw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)