UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WWCubOJAbIkVchTAU9gMhqDVMQNiygqBebnixoz5rsM='
WHERE
key_id = '5b72d1e2714b8ebdf9ca64616aeaf346ecbaeadb4dc42556486322efe40dd510'
AND (
token = 'WWCubOJAbIkVchTAU9gMhqDVMQNiygqBebnixoz5rsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)