UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vCgk90NA3Awd9t30rrdb8JPvaH12BeTuY/zZA8bcAtQ='
WHERE
key_id = '198815e3df204c2c86a706d0b955a109f61c6e057a6bf8a1acb96a5862060ea2'
AND (
token = 'vCgk90NA3Awd9t30rrdb8JPvaH12BeTuY/zZA8bcAtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)