UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HUfO1IqN6dbf+pbC7v5PFHQ2FR/QvYXxpKZFC5mxh/A='
WHERE
key_id = '84cf2e7d941d7b698deb66ee0b5469c0d144c5c93a353f511d5979735970aa64'
AND (
token = 'HUfO1IqN6dbf+pbC7v5PFHQ2FR/QvYXxpKZFC5mxh/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)