UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/bzFraI7YhAG8Ksw8koK3s6pcp+pyBuJfvp/KKSkoGU='
WHERE
key_id = '2a9163f1192f1d07ab96801cf432ce05fb1a15f7a1333b8e3defe7fe2391cee4'
AND (
token = '/bzFraI7YhAG8Ksw8koK3s6pcp+pyBuJfvp/KKSkoGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)