UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1QM5HibeGXeAIZrAg8QMRaVR0LiUxwmAzqh/lgQkI84='
WHERE
key_id = 'bb7d668185b3f93dc3164c5cde0a9ac4396bc58c34fc8e2592992a38e2ae2de2'
AND (
token = '1QM5HibeGXeAIZrAg8QMRaVR0LiUxwmAzqh/lgQkI84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)