UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNpKftwNmas9LNDN2tPD8laVRXVc6Jj4jTOqj1fbS8I='
WHERE
key_id = '2b8acb54fc04def101e56a9cac041ec892fc0abb3fc08767f66ee25ea6cc6b17'
AND (
token = 'zNpKftwNmas9LNDN2tPD8laVRXVc6Jj4jTOqj1fbS8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)