UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZC3oo+bKoIWoe1V4bVxwz4hnC/bVRIvfxOO7RsX9jv4='
WHERE
key_id = '8ee522ac002ae989958e463f2e8093487e9f41102a224bc6996663a9eb7fc465'
AND (
token = 'ZC3oo+bKoIWoe1V4bVxwz4hnC/bVRIvfxOO7RsX9jv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)