UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vlafH0mRLN3shtGeYOmcWxvRSp+loe7L+7ceet9YOS4='
WHERE
key_id = '476289b152a4e5f0b7a27cdf7c544949c92bc751323ae263577b079ecb812174'
AND (
token = 'vlafH0mRLN3shtGeYOmcWxvRSp+loe7L+7ceet9YOS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)