UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZiK1uxdZ31qii6RLcEyRqTzPRXEYlXa2sP7fYgG3iU='
WHERE
key_id = '4e60c603482eda0616ef7086dc5f2e7a76ad02aff15a345064a955827acbc604'
AND (
token = '0ZiK1uxdZ31qii6RLcEyRqTzPRXEYlXa2sP7fYgG3iU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)