UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8NpBLpfTTd0ZVm+sZ3geOZvDkC0EptjLLyiox+VMNc='
WHERE
key_id = 'e6b3b973009173eb7b1bdd4451cf7edf308b28d0f4b86de43dcd3457279d3fe2'
AND (
token = 'H8NpBLpfTTd0ZVm+sZ3geOZvDkC0EptjLLyiox+VMNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)