UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QnHyfrbO1L75N+9UGXK490w6GO6bjiXKTtCXG27IMxI='
WHERE
key_id = '8c7b0c61b31080071fb3cbbb6db4fb0f88011f16c32eff6d165fc5db689ccf77'
AND (
token = 'QnHyfrbO1L75N+9UGXK490w6GO6bjiXKTtCXG27IMxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)