UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bon/C8/5/YbrV8gbo/oGZ5pMB5Nq3qeC0kEesDv9zsY='
WHERE
key_id = '2a78b9de9ab9be6cb5a2235b6b78d4c739153b1cb16f70b82dd189d905610fac'
AND (
token = 'Bon/C8/5/YbrV8gbo/oGZ5pMB5Nq3qeC0kEesDv9zsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)