UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uICGFzI1kHMu0zWDxSTmGRCnfCY4UtdrLQ8JX3CKIWc='
WHERE
key_id = '9ba67897f866f3c7a036839ff24a22ee600ea1cb59e3fb3cb70fac26215a04b2'
AND (
token = 'uICGFzI1kHMu0zWDxSTmGRCnfCY4UtdrLQ8JX3CKIWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)