UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mQ7NlwbWQ4CJNT6A66l8nyja0v0kINW+MW24f/SFRRg='
WHERE
key_id = 'd99b34324fc857d7ccc5ff66ea4b55748e90596326a0d2a9a38e72d99d7e849f'
AND (
token = 'mQ7NlwbWQ4CJNT6A66l8nyja0v0kINW+MW24f/SFRRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)