UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3XNkjefbcB+Vjxj8f8kAADJAWNY7XdiQH8TfBu9dmzs='
WHERE
key_id = 'a96ecd28c1c31badfb22cf7aba5f3cbdd3f56d30b95a00aa021ac6b5f16c6c9a'
AND (
token = '3XNkjefbcB+Vjxj8f8kAADJAWNY7XdiQH8TfBu9dmzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)