UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NYye7xKJyR4EtsT3eLSIOj8jrwdU5YnAVz4z88IUzJc='
WHERE
key_id = 'ac75836b5b1917fca1d0eb7d78db4dff0f6cb669b31a1878a452664caa669818'
AND (
token = 'NYye7xKJyR4EtsT3eLSIOj8jrwdU5YnAVz4z88IUzJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)