UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xVo+epkuNuosAfPkTxQs0KG857ULYt3+XVN+RQlwRCA='
WHERE
key_id = '8e1a9fbda701f1cb4b04bee0557b21f21c8511643d81d50a42a877da9b433430'
AND (
token = 'xVo+epkuNuosAfPkTxQs0KG857ULYt3+XVN+RQlwRCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)