UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hSXVEazTFY/UMVzCq8co1m0Wm3XHBansyQGo/cmUAb8='
WHERE
key_id = '9989f25fad534690b481229be7b31745692e59610258e5c304e390860b65fe04'
AND (
token = 'hSXVEazTFY/UMVzCq8co1m0Wm3XHBansyQGo/cmUAb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)