UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VnbZ7jH+vdDSO+Lc3Q9MgZyl7d6APe7e1iPbMIF6+YU='
WHERE
key_id = '8bd30c68f520180fac252f619725ab542861d909641dee1e33ed8d89adf5edf1'
AND (
token = 'VnbZ7jH+vdDSO+Lc3Q9MgZyl7d6APe7e1iPbMIF6+YU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)