UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yXKYjlD9qXNxzpGKd0V2fh4VDyeVG8W6GWHJlUnW+hA='
WHERE
key_id = '99d61f806ed17113596360676b019c5d6ab99e4664073f7b60af4ce7de905dfa'
AND (
token = 'yXKYjlD9qXNxzpGKd0V2fh4VDyeVG8W6GWHJlUnW+hA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)