UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bNzGSsH3wT0J6VeP9VsIvmoS5zfA0unsI5gl7mJePmg='
WHERE
key_id = 'a75f31257f00acfd9687f65d36c04e9be9e5ca6eb8d5eabf8f71b750b9f375e8'
AND (
token = 'bNzGSsH3wT0J6VeP9VsIvmoS5zfA0unsI5gl7mJePmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)