UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ugPfIQQ60vWmgB66QWD+gWuF37UMKmET9/EU3FpC7tM='
WHERE
key_id = '7f12a3f688dae70b56926ac2eef64b733262b54b8711915bed71c32aa8b9985f'
AND (
token = 'ugPfIQQ60vWmgB66QWD+gWuF37UMKmET9/EU3FpC7tM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)