UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KvI0QT6saTfTu8Byb7HJvoVcPQwcXZyFd8zI6+3IyVo='
WHERE
key_id = 'a47adf344092b4f862c9def85e1823fa25f1d9535c90e9f267619ab3b5c22146'
AND (
token = 'KvI0QT6saTfTu8Byb7HJvoVcPQwcXZyFd8zI6+3IyVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)