UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46rSZwQpYRIGesJdSxfG6gX2+JuseTbv1yWi0zwRIX0='
WHERE
key_id = '7bebf44b915dac9d13ca07b5f1f1417dfc3b18000b7d67a898aa668149f4aae9'
AND (
token = '46rSZwQpYRIGesJdSxfG6gX2+JuseTbv1yWi0zwRIX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)