UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F9CCb46vpVELvFgHFuY42jBX5L30betVIHu/ogX590U='
WHERE
key_id = '9b2a7fb3153ccd75c6ae0c3d323b5286ac71e42ec4ed29804eb26412dd022a00'
AND (
token = 'F9CCb46vpVELvFgHFuY42jBX5L30betVIHu/ogX590U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)